delete from Servico

set identity_insert Servico on 
insert into Servico
(Codigo,
Descricao,
Inativo,
DataHoraUltimaGravacao,
UsuarioUltimaGravacao
)
select 
Codigo_srv,
Descricao_srv,
Inativo_srv,
UltimaGravacao_srv,
Username_usr
from Dados_db..Servicos_tb
set identity_insert Servico off




insert into ServicoPreco
(CodServico,
PrecoCusto,
PrecoVenda,
CodEmp
)
select 
Codigo_srv,
PrecoCusto_srv,
PrecoVenda_srv,
1
from Dados_db..Servicos_tb